USE [CMS]
GO

/****** Object:  View [dbo].[VW_Administration]    Script Date: 12/27/2012 08:08:40 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE VIEW [dbo].[VW_Administration]
AS
SELECT     ADM_ID, ADM_CODE, ADM_NAME, ADM_ACTIVE, ADM_DATE, MUT_DELETED, ADM_COMMENTS
FROM         dbo.Administration
WHERE     (MUT_DELETED IS NULL)

GO
